using System;
using System.Collections.Generic;
using System.Text;
using BusinessObjects.BO_Actions.Trash;
using Entity.StoreProcedure;
using BusinessObjects;
using System.Data;
using BusinessObjects;
namespace BusinessObjects.BO_GetObjects
{
    public static class BO_Trash
    {
        public static DataTable SelectAll()
        {
            try
            {
                BOTrash_Select_All action = new BOTrash_Select_All();
                usp_Trash_Select_All entity = new usp_Trash_Select_All();

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectModule(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Module action = new BOTrash_Select_Module();
                usp_Trash_Select_Module entity = new usp_Trash_Select_Module();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectDealOfTheDay(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_DealOfTheDay action = new BOTrash_Select_DealOfTheDay();
                usp_Trash_Select_DealOfTheDay entity = new usp_Trash_Select_DealOfTheDay();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;
                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectEvents(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Event action = new BOTrash_Select_Event();
                usp_Trash_Select_Events entity = new usp_Trash_Select_Events();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;
                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectMembers(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Members action = new BOTrash_Select_Members();
                usp_Trash_Select_Members entity = new usp_Trash_Select_Members();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;
                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectProducts(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Products action = new BOTrash_Select_Products();
                usp_Trash_Select_Products entity = new usp_Trash_Select_Products();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;
                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectTickets(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Tickets action = new BOTrash_Select_Tickets();
                usp_Trash_Select_Tickets entity = new usp_Trash_Select_Tickets();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;
                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectAdv(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Adv action = new BOTrash_Select_Adv();
                usp_Trash_Select_Adv entity = new usp_Trash_Select_Adv();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectCategory(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Categories action = new BOTrash_Select_Categories();
                usp_Trash_Select_Categories entity = new usp_Trash_Select_Categories();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectAdministrator(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Administrators action = new BOTrash_Select_Administrators();
                usp_Trash_Select_Administrators entity = new usp_Trash_Select_Administrators();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectModules(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Modules action = new BOTrash_Select_Modules();
                usp_Trash_Select_Modules entity = new usp_Trash_Select_Modules();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectArticles(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Articles action = new BOTrash_Select_Articles();
                usp_Trash_Select_Articles entity = new usp_Trash_Select_Articles();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable SelectGroup(int startIndex, int pageCount, int status)
        {
            try
            {
                BOTrash_Select_Group_Admin action = new BOTrash_Select_Group_Admin();
                usp_Trash_Select_Group_Admin entity = new usp_Trash_Select_Group_Admin();
                entity.STARTINDEX = startIndex;
                entity.MAXRECORDS = pageCount;
                entity.STATUS = status;

                return action.ExecuteAndReturnDataTable(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteCategory(int category)
        {
            try
            {
                BOTrash_Delete_Categories action = new BOTrash_Delete_Categories();
                usp_Trash_Delete_Categories entity = new usp_Trash_Delete_Categories();
                entity.CATEGORY_ID = category;

                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteArticles(int article_id)
        {
            try
            {
                BOTrash_Delete_Articles action = new BOTrash_Delete_Articles();
                usp_Trash_Delete_Articles entity = new usp_Trash_Delete_Articles();
                entity.ARTICLE_ID = article_id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteModule(int Module_id)
        {
            try
            {
                BOTrash_Delete_Module action = new BOTrash_Delete_Module();
                usp_Trash_Delete_Module entity = new usp_Trash_Delete_Module();
                entity.MODULE_ID = Module_id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteAdv(int Picture_id)
        {
            try
            {
                BOTrash_Delete_Adv action = new BOTrash_Delete_Adv();
                usp_Trash_Delete_Adv entity = new usp_Trash_Delete_Adv();
                entity.PICTURE_ID = Picture_id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteThreads(int thread_id)
        {
            try
            {
                BOTrash_Delete_Threads action = new BOTrash_Delete_Threads();
                usp_Trash_Threads_Delete entity = new usp_Trash_Threads_Delete();
                entity.THREAD_ID = thread_id;

                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteAdmin(int category)
        {
            try
            {
                BOTrash_Delete_Sec_Administrators action = new BOTrash_Delete_Sec_Administrators();
                usp_Trash_Delete_Sec_Administrators entity = new usp_Trash_Delete_Sec_Administrators();
                entity.ADMIN_ID = category;

                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteGroup(int category)
        {
            try
            {
                BOTrash_Delete_Sec_Group_Admin action = new BOTrash_Delete_Sec_Group_Admin();
                usp_Trash_Delete_Sec_Group_Admin entity = new usp_Trash_Delete_Sec_Group_Admin();
                entity.GROUP_ADMIN_ID = category;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteMenu(int category)
        {
            try
            {
                BOTrash_Delete_Sec_Menu action = new BOTrash_Delete_Sec_Menu();
                usp_Trash_Delete_Sec_Menu entity = new usp_Trash_Delete_Sec_Menu();
                entity.SYSTEM_MENU_ID = category;

                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteTickets(int id)
        {
            try
            {
                BOTrash_Delete_Tickets action = new BOTrash_Delete_Tickets();
                usp_Trash_Delete_Tickets entity = new usp_Trash_Delete_Tickets();
                entity.TICKET_ID = id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteProducts(int id)
        {
            try
            {
                BOTrash_Delete_Products action = new BOTrash_Delete_Products();
                usp_Trash_Delete_Products entity = new usp_Trash_Delete_Products();
                entity.PRODUCT_ID = id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteMembers(int id)
        {
            try
            {
                BOTrash_Delete_Members action = new BOTrash_Delete_Members();
                usp_Trash_Delete_Members entity = new usp_Trash_Delete_Members();
                entity.MEMBER_ID = id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteEvents(int id)
        {
            try
            {
                BOTrash_Delete_Event action = new BOTrash_Delete_Event();
                usp_Trash_Delete_Event entity = new usp_Trash_Delete_Event();
                entity.EVENT_ID = id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static bool DeleteDealOfTheDay(int id)
        {
            try
            {
                BOTrash_Delete_DealOfTheDay action = new BOTrash_Delete_DealOfTheDay();
                usp_Trash_Delete_DealOfTheDay entity = new usp_Trash_Delete_DealOfTheDay();
                entity.DEAL_OF_DAY_ID = id;
                return action.ExecuteAndReturnBooleanValue(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}

